MESCIUS SPREAD for Windows Forms 15.0J
GetValidConditionalFormat(Int32,Int32,IPrePaintConditionalFormattingRule[],IPrePaintTextConditionalFormattingRule[]) メソッド
使用例 

行インデックス
列インデックス
描画前条件付き書式ルール
テキスト描画前条件付き書式ルール
有効な条件付き書式を取得します。
構文
'宣言
 
Public Sub GetValidConditionalFormat( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByRef prePaintCFRules() As IPrePaintConditionalFormattingRule, _
   ByRef prePaintTextCFRules() As IPrePaintTextConditionalFormattingRule _
) 

パラメータ

row
行インデックス
column
列インデックス
prePaintCFRules
描画前条件付き書式ルール
prePaintTextCFRules
テキスト描画前条件付き書式ルール
使用例
次のサンプルコードは、GetValidConditionalFormatメソッドを使用します。
private void Form1_Load(object sender, EventArgs e)
        {
            fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
            fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
            fpSpread1.Sheets[0].Cells[1, 1].Value = 10;
            fpSpread1.Sheets[0].Cells[0, 2].Value = 1;            
        }

        private void button1_Click(object sender, EventArgs e)
        {
FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 3, false);
unary.Operator = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo;
//unary.Value = 3;
unary.BackColor = Color.Red;
unary.FontStyle = new FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold);

fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, unary);
fpSpread1.ActiveSheet.SetConditionalFormatting(0, 0, unary);

FarPoint.Win.Spread.IPrePaintConditionalFormattingRule[] prePaintRule;
FarPoint.Win.Spread.IPrePaintTextConditionalFormattingRule[] prePaintTextRule;
fpSpread1.ActiveSheet.GetValidConditionalFormat(0, 0, out prePaintRule, out prePaintTextRule);

FarPoint.Win.Spread.PrePaintResult pp = prePaintRule[0].Execute(0, 0, fpSpread1.ActiveSheet.Cells[0, 0].Value);
FarPoint.Win.Spread.StyleInfo source = new FarPoint.Win.Spread.StyleInfo();
fpSpread1.ActiveSheet.Cells[1, 1].Value = 3;
FarPoint.Win.Spread.PrePaintResult pp1 = prePaintRule[0].Execute(1, 1, fpSpread1.ActiveSheet.Cells[1, 1].Value);        
        }
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        FpSpread1.Sheets(0).Cells(0, 0).Value = 3
        FpSpread1.Sheets(0).Cells(1, 0).Value = 2
        FpSpread1.Sheets(0).Cells(1, 1).Value = 10
        FpSpread1.Sheets(0).Cells(0, 2).Value = 1
    End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Unary comparison CF
Dim unary As New FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 3, False)
unary.[Operator] = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo
'unary.Value = 3;
unary.BackColor = Color.Red
unary.FontStyle = New FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold)

FpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, unary)
FpSpread1.ActiveSheet.SetConditionalFormatting(0, 0, unary)

Dim prePaintRule As FarPoint.Win.Spread.IPrePaintConditionalFormattingRule()
Dim prePaintTextRule As FarPoint.Win.Spread.IPrePaintTextConditionalFormattingRule()
FpSpread1.ActiveSheet.GetValidConditionalFormat(0, 0, prePaintRule, prePaintTextRule)

Dim pp As FarPoint.Win.Spread.PrePaintResult = prePaintRule(0).Execute(0, 0, FpSpread1.ActiveSheet.Cells(0, 0).Value)
Dim source As New FarPoint.Win.Spread.StyleInfo()
FpSpread1.ActiveSheet.Cells(1, 1).Value = 3
Dim pp1 As FarPoint.Win.Spread.PrePaintResult = prePaintRule(0).Execute(1, 1, FpSpread1.ActiveSheet.Cells(1, 1).Value)
    End Sub
参照

SheetView クラス
SheetView メンバ

 

 


© MESCIUS inc. All rights reserved.